Step 1: Create A District Name
a. Fields = .District Name Measure (remove period from front in name)
b. Select formatting (paint roller), in general X position = 743, Y position = 0, Width = 292, Height = 68
c. Data Label Color = white, text size = 20, font = Constantia
d. Background Color = Custom (4A588A)
Step 2: Create Last Refreshed Card
a. Fields = .Last Refreshed Local (remove period from front in name)
b. Select formatting, in general X position = 0, Y position = 76, Width = 151, Height = 69
c. Data Label, Color = black, text size = 10, font = Constantia
d. Category, Color = black, text size = 9, font = Constantia
Step 3: Create Violent Crime Rate Card
a. Fields = .Violent Crime Rate (remove period from front in name)
b. Select formatting, in general X position = 9, Y position = 270, Width = 139, Height = 81
c. Data Label, Color = Custom(1E5A8E), text size = 20, font = Constantia
d. Category, Color = black, text size = 10, font = Constantia
e. Background = Light gray
f. Border = dark gray
g. Change Violent Crime Rate to a percentage.
Step 4: Create VCR YOY Card
a. Fields = .Diffs VCR YOY (change name to VCR YOY)
b. Select formatting, in general X position = 9, Y postion = 373, Width = 139, Height = 81
c. Data Label, Color = color scale format, field Violent Crime Rate YOY%, Minimum = Custom, Custom Color = 00800, Value = .000001, Maximum = Custom, Custom Color = FF0000, Value = 0, text size = 20, font = Constantia
d. Category, Color = black, text size = 10, font = Constantia
e. Background = light gray
Step 5: Create Major Crime Rate Card
a. Copy (Ctrl + C) and paste (Ctrl + V) the Violent Crime Rate Card
b. Change field to .Major Crime Rate (remove period in name)
c. Select formatting, in general X position = 9, Y position = 475, Width = 139, Height = 81
d. Data label, Color = Custom (BD890F)
e. Make sure it is formatted to a percentage
Step 6: Create MCR YOY
a. Fields = .Diffs MCR YOY (rename to MCR YOY)
b. Select formatting, in general X position = 9, Y position = 579, Width = 139, Height = 81
c. Data Label, change field value to Major Crime Rate YOY in conditional format
Step 7: Create Year Slicer
a. Field = Occurred Date / Year
b. Switch from a slider to a drop down
c. Select formatting, in general X position = 9, Y position = 166, Width = 139, Height = 81
d. Selection controls, Ctrl select off, Select all on
e. Slicer header, Color = black, text size = 11, font = Constantia
f. Background = light gray
g. Border = dark gray
Check out this article on Crime in the United States for a better understanding.